<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body style="padding:10px;">
<p>说明：
    <span>必须使用了多语言设置</span>
</p>
<br/>
<p>正例：</p>
<p>1、组织（本表origin_id, 他表org_origin_id，查询时需注意生效日期[enable_date],失效日期[unenable_date]，审核状态[audit_status]，是否失效 参考: PerOrgsDao.xml</p>
<p>2、岗位（本表origin_id, 他表post_origin_id，生效日期[enable_date],失效日期[unenable_date]，审核状态[audit_status]， 是否删除[is_delete] 参考: PerPostDao.xml</p>
<p>3、人员（本表origin_id, 其他表emp_origin_id，生效日期[enable_date],失效日期[unenable_date]，审核状态[audit_status]，状态[status]， 是否删除[is_delete] 参考: EmpInfoDao.xml</p>
<div style="margin:10px;padding:10px;border:1px solid #000000;white-space: pre-line;">
<br/>    SELECT * FROM per_orgs o
<br/>    JOIN emp_info e ON o.origin_id = e.org_origin_id AND e.origin_id = #{empOriginId}
<br/>    AND o.enable_date &lt;![CDATA[ &lt;= ]]&gt; #{date}
<br/>    AND o.unable_date &lt;![CDATA[ &gt; ]]&gt; #{date}
<br/>    AND o.audit_status in (3,5)
<br/>    AND o.is_delete = 0
<br/>    AND e.enable_date &lt;![CDATA[ &lt;= ]]&gt; #{date}
<br/>    AND e.unable_date &lt;![CDATA[ &gt; ]]&gt; #{date}
<br/>    AND e.status = 0
<br/>    AND e.audit_status in (3,5)
<br/>    AND e.is_delete = 0;
<br/>
<br/>    SELECT * FROM per_post WHERE id = #{id}
<br/>    AND enable_date &lt;![CDATA[ &lt;= ]]&gt; #{date} AND unable_date &lt;![CDATA[ &gt; ]]&gt; #{date}
<br/>    AND audit_status in(3,5)
<br/>    AND is_delete = 0
<br/>
<br/>    select name
<br/>    from emp_info
<br/>    WHERE enable_date &lt;![CDATA[ &lt;= ]]&gt; #{date} AND unable_date &lt;![CDATA[ &gt; ]]&gt; #{date}
<br/>    AND status = 0
<br/>    AND audit_status in (3,5)
<br/>    AND is_delete = 0
</div>
<br/>
<p>反例：</p>
<div style="margin:10px;padding:10px;border:1px solid #000000;white-space: pre-line;">
    无
</div>
</body>
</html>